Dashboard 03 - Creating Matrix, Map, & Line and Stacked Column chart Visualizations - Part 02 21
In this step, we will continue creating a matrix, map and chart in the 3rd dashboard.
To get you started, use the previous map as a template. Click on the Total Police Incidents by Time of Day, press Ctrl+C to copy and Ctrl+V to paste it.
From the copied map, change it to a Line and Stacked Column chart and set up as follows:
To create the chart, click the Line and Stacked Column chart iconVisualizations
Fields
Select the following:
A_KeyMeasures -> .AVG_Crimes_PerWeekDay - Under Visualizations, drag & drop it in the Column Values section
A_KeyMeasures -> .YOY_AVG_Crimes_PerDay% - Under Visualizations, drag & drop it in the Line Values section
A_KeyMeasures -> .YOY_AVG_Crimes_PerDay% - Under Visualizations, drag & drop it in the Tooltips section
Raleigh_Police_Incidents_NIBRS -> reported_dayofwk - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> reported_hour - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> Time_Of_Day - Under Visualizations, drag & drop it in the Column Series section
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.AVG_Crimes_PerWeekDay = Avg Crimes/WeekDay
reported_dayofwk = Reported Day of the Week
reported_hour = Reported Hour
Time_Of_Day= Time Of Day
Summary:
Under Format -> General: X Position = 0 , Y Position = 652 , Width = 605 , Height = 321
Under
Format -> Legend -> Set it to ON , Position = Top Center , Title = OFF , Color
= 000000 , Font Family = Segoe UI , Text Size = 11 pt , Style = Markers
Only
Under Format -> X Axis -> Color =
000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF
Under
Format -> Y Axis (Column) -> Position = Left , Scale type =
Linear -> Start = 0.1
-> Color =
000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF ,
Color = 000000 , Stroke Width = 2 , Line Style = Dotted , Show
Secondary = ON , Y-Axis (Line) Position =
Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font
Family = Segoe UI , Title = OFF
Under Format -> Data
Colors -> YOY AVG Crimes/Day =
6B007B , Afternoon = F0E199 , Late Night = 41A4FF , Morning = EB895F , Night = 717BC5
Under Format -> Data Labels -> Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 13 pt , Font Family = Segoe UI , Show Background = Off ,
Customize Series = ON ,
(Select Afternoon -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,
(Select Late Night -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,(Select Morning -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,
(Select Night -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,
(Select YOY -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,
Under Format -> Shapes ->
Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style =
Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5
Under Format -> Title -> Set it to ON , Title Text = Average Police Incidents Per Day & Time of Day , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)
Under Format -> Background -> Set it to ON , Color = FFF
Under Format -> Border -> Set it to ON , Color = 666666